Skip to main content

Adhoc Bind Parameters

  • This Document shows information of how we can bind and send parameters in adhoc report, if report dataset has parameters in it.

Objective​

  • Send Parameters in Adhoc Report

Prerequisite​

  • Used Sales.cds for this example.

Download Bind_Parameter.zip file from link given Bind_Parameter.zip.

  • After downloading the zip file, add the Parameter Sales DS.ds into the Dataset Section of OPNBI for this example. To add it into OPNBI follow this Link.

Steps to send Bind Parameter​

  1. Click here & create Adhoc Report using Table by following the given steps. While creating the Adhhoc Report using Table, Use Parameter Sales DS.ds which you have downloaded at the start of this document. (For this example; Follow steps till no:-22)

  2. After you followed the above step, your screen will look as per below:

    Docusaurus Slash Introduction

  3. To run the Adhoc Report using Table Component, click on Run in the top most right corner as follows:-

    Docusaurus Slash Introduction

  4. Click on RUN option from top-right , which will open the following dialog box:-

    Docusaurus Slash Introduction

info

  • It will ask for the parameters used in dataset, if you leave it blank, report will be generated with default value provided in dataset.

  • Click here to know how to create dataset using Parameter.

  1. Provide parameter values and click on send button.

  2. Your report will be generated with applied values of parameter.